Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_1079

R_1079

PerfService

Examination

PerfServiceID

 

 

R_1080

R_1080

Infection

LEventInfection

InfectionID

 

 

R_1081

R_1081

Event

LEventInfection

EventID

 

 

R_1083

R_1083

BodyPart

LSurgeryBodyPart

BodyPartID

 

 

R_1084

R_1084

Service

Treatment

ServID

 

 

R_1085

R_1085

PerfService

Treatment

PerfServiceID

 

 

R_1089

R_1089

InfectionClass

InfectionClassText

InfectionClassID

 

 

R_1096

R_1096

Material

Examination

MaterialID

 

 

R_1097

R_1097

Infection

LInfectionKind

InfectionID

 

 

R_1129

R_1129

InfectionEffect

InfectionEffectText

InfectionEffectID

 

 

R_1130

R_1130

InfectionEffect

LInfectionEffect

InfectionEffectID

 

 

R_1131

R_1131

Infection

LInfectionEffect

InfectionID

 

 

R_1579

R_1579

PreventAction

PreventActionText

PreventActionID

 

 

R_1581

R_1581

Microbe

MicrobeText

MicrobeID

 

 

R_1585

R_1585

PreventAction

LInfectionPreventAction

PreventActionID

 

 

R_1586

R_1586

Infection

LInfectionPreventAction

InfectionID

 

 

R_1587

R_1587

Microbe

LInfectionMicrobe

MicrobeID

 

 

R_1588

R_1588

Infection

LInfectionMicrobe

InfectionID

 

 

R_3000

R_3000

InfectionQualification

InfectionQualificationText

InfectionQualificationID

 

 

R_3001

R_3001

InfectionQualification

Infection

InfectionQualificationID

 

 

R_3002

R_3002

RiskGroup

RiskGroupText

RiskGroupID

 

 

R_3003

R_3003

Infection

LInfectionRiskGroup

InfectionID

 

 

R_3004

R_3004

RiskGroup

LInfectionRiskGroup

RiskGroupID

 

 

R_3005

R_3005

ExternalIdentifier

LInfectionIdentifier

IdentifierTypeID; ExternalValue

 

 

R_3006

R_3006

Infection

LInfectionIdentifier

InfectionID

 

 

R_8500

R_8500

AdditExamination

AdditExaminationText

AdditExaminationID

 

 

R_8501

R_8501

Infection

LInfectionAdditExamination

InfectionID

 

 

R_8502

R_8502

AdditExamination

LInfectionAdditExamination

AdditExaminationID

 

 

R_8959

R_8959

ClinicalSigns

ClinicalSignsText

ClinicalSignsID

 

 

R_8960

R_8960

RiskFactorType

RiskFactorTypeText

RiskFactorTypeID

 

 

R_8961

R_8961

PreventiveAction

PreventiveActionText

PreventiveActionID

 

 

R_8962

R_8962

Infection

LInfectionPreventiveAction

InfectionID

 

 

R_8963

R_8963

PreventiveAction

LInfectionPreventiveAction

PreventiveActionID

 

 

R_8964

R_8964

RiskFactor

LPatogenInstanceRiskFactor

RiskFactorID

 

 

R_8965

R_8965

PatogenInstance

LPatogenInstanceRiskFactor

PatogenInstanceID

 

 

R_8966

R_8966

RiskFactor

LSurgeryRiskFactor

RiskFactorID

 

 

R_8967

R_8967

Surgery

LSurgeryRiskFactor

SurgeryID

 

 

R_8968

R_8968

PatogenInstance

LPatogenInstanceClinicalSigns

PatogenInstanceID

 

 

R_8969

R_8969

ClinicalSigns

LPatogenInstanceClinicalSigns

ClinicalSignsID

 

 

R_8970

R_8970

Infection

LInfectionPregnancyRiskFactor

InfectionID

 

 

R_8971

R_8971

RiskFactor

LInfectionPregnancyRiskFactor

RiskFactorID

 

 

R_8972

R_8972

RiskFactorType

RiskFactor

RiskFactorTypeID

 

 

R_9120

R_9120

ExternalOrgUnit

PatogenInstance

APSourceHospitalID

 

 

R_9121

R_9121

ExternalOrgUnit

PatogenInstance

APClassSourceHospitalID

 

 

R_9280

R_9280

ResourceItem

Treatment

ResourceID

 

 

R_9281

R_9281

Unit

Treatment

UnitID

 

 

R_9282

R_9282

Frequency

Treatment

FrequencyID

 

 

R_9283

R_9283

ApplicationWay

Treatment

ApplicationWayID

 

 

R_9284

R_9284

AntimicrobialDrugs

AntimicrobialDrugsText

AntimicrobialDrugsID

 

 

R_9285

R_9285

PatogenType

PatogenTypeText

PatogenTypeID

 

 


1  2  3